
package com.zmks.jkgj.xuexiao.service.impl;



import java.util.List;

import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Property;
import org.hibernate.criterion.Restrictions;

import com.zmks.jkgj.core.dao.IGenericDao;
import com.zmks.jkgj.core.service.impl.GenericServiceImpl;
import com.zmks.jkgj.xuexiao.pojo.CrctBusiScoreItem;
import com.zmks.jkgj.xuexiao.pojo.CrctObjSchool;
import com.zmks.jkgj.xuexiao.service.ICrctBusiScoreItemService;
import com.zmks.jkgj.xuexiao.service.ICrctObjSchoolService;
import com.zmks.jkgj.xuexiao.view.Grade_Class_Teacher_View;
import com.zmks.jkgj.xuexiao.vo.CrctBusiScoreItemVO;
import com.zmks.jkgj.xuexiao.vo.CrctObjSchoolVO;


public class CrctBusiScoreItemServiceImpl   extends GenericServiceImpl<CrctBusiScoreItem, CrctBusiScoreItemVO>  implements ICrctBusiScoreItemService {


	public CrctBusiScoreItemServiceImpl(IGenericDao<CrctBusiScoreItem> genericDao) {
		super(genericDao);
	}

	public List<CrctBusiScoreItem> getCoulmn(Long sheet_sch_oid) {
		 DetachedCriteria query = DetachedCriteria.forClass(CrctBusiScoreItem.class);
		 query.add(Property.forName("sheet_sch_oid").eq(sheet_sch_oid));
		 query.setProjection(Projections.distinct(Property.forName("subject")));
		 
		 return   dao.getList(query);
	}
}
